package marchsoft.modules.four.common.mapper;

import marchsoft.base.BasicMapper;
import marchsoft.modules.four.common.entity.EStudent;
import marchsoft.modules.four.h5.entity.bo.EStudentBO;
import marchsoft.modules.four.h5.entity.dto.EStudentDTO;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

@Component
public interface EStudentMapper extends BasicMapper<EStudent> {

	@Select("select id,university_id,name,sex,student_num,password,is_deleted as deleted,avatar_path from e_student where id=#{id} and is_deleted=0")
	EStudentDTO selectStudentById(String id);
	@Select("select id,password from e_student where is_deleted=0 and university_id=#{universityId} and student_num=#{studentNum}")
	EStudentBO selectIdByDepStu(Long universityId, String studentNum);
}
